Matthew J McAteer
Matthew J McAteer
Reactions
-
Re: Need help finishing formula for status
HI @Edward Spencer, Try this: =IF(AND(Done?@row = 0, [Server must be 100% Cutover to New Box by:]@row < TODAY()), "Red", IF(AND(Done?@row = 0, [Server must be 100% Cutover to New Box by:…2 · -
Re: December Question of the Month 💭 Join the conversation and receive a badge
I am proud that I have finally focused on creating a true work / life balance. Since a lot of my work over the past year has increasingly involved the use of Smartsheet, I have capitalized on so many…2 · -
Re: Remove Empty Space at Bottom of Dashboard
Hi @Sunil.Mukerjee, If you go into edit mode on the dashboard and right click in the whitespace, there is an option to Consolidate Empty Space. Sometimes when you do this it moves some of your widget…1 · -
Re: Method to check whether a Assessment Date has passed upon multiple cells within a row.
@Matthew Drake If you wanted to build a nested IF statement, you would add RYG ball Symbol column and use a formula something like this: =IF(AND(TODAY() > [Knowledge/SJT/MCQ/Skills Test Date &…1 · -
Re: Total Age tracker overwrites last modified
Hi Mike, If you use an Automated Workflow to add a date, the workflow can be set to trigger when a specific column or columns are updated. If you add a Last Updated Date column, you can set up a work…1 ·
